package labox.innovation.gameserver.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import labox.innovation.db.core.L2DatabaseFactory;
//import labox.innovation.gameserver.instancemanager.SiegeManager;
import labox.innovation.gameserver.model.actor.instance.FuzePcInstance;

/**
 * This class ...
 *
 * @version $Revision: 1.5.4.2 $ $Date: 2005/03/27 15:29:33 $
 */
public class L2ClanMember {
	
	private L2Clan _clan;

	private long _objectId;

	private String _name;

	private String _title;

	private int _powerGrade;

	private int _level;

	private int _classId;

	private boolean _sex;

	private int _raceOrdinal;

	private FuzePcInstance _player;

	private int _pledgeType;

	private int _apprentice;

	private int _sponsor;

	public L2ClanMember(L2Clan clan, String name, int level, int classId, int objectId, int pledgeType, int powerGrade, String title, boolean sex, int raceOrdinal) {
		if (clan == null)
			throw new IllegalArgumentException("Can not create a ClanMember with a null clan.");
		_clan = clan;
		_name = name;
		_level = level;
		_classId = classId;
		_objectId = objectId;
		_powerGrade = powerGrade;
		_title = title;
		_pledgeType = pledgeType;
		_apprentice = 0;
		_sponsor = 0;
		_sex = sex;
		_raceOrdinal = raceOrdinal;

	}

	public L2ClanMember(L2Clan clan, FuzePcInstance player) {
		_clan = clan;
		_name = player.getName();
		_level = player.getLevel();
		_classId = player.getClassId().getId();
		_objectId = player.getObjectId();
//		_pledgeType = player.getPledgeType();
//		_powerGrade = player.getPowerGrade();
//		_title = player.getTitle();
//		_sponsor = 0;
//		_apprentice = 0;
//		_sex = player.getAppearance().getSex();
//		_raceOrdinal = player.getBioType().ordinal();
	}

	public L2ClanMember(FuzePcInstance player) {
		if (player.getClan() == null)
			throw new IllegalArgumentException("Can not create a ClanMember if player has a null clan.");
		_clan = player.getClan();
		_player = player;
		_name = _player.getName();
		_level = _player.getLevel();
		_classId = _player.getClassId().getId();
		_objectId = _player.getObjectId();
//		_powerGrade = _player.getPowerGrade();
//		_pledgeType = _player.getPledgeType();
//		_title = _player.getTitle();
//		_apprentice = 0;
//		_sponsor = 0;
//		_sex = _player.getAppearance().getSex();
//		_raceOrdinal = _player.getBioType().ordinal();
	}

	public void setPlayerInstance(FuzePcInstance player) {
		if (player == null && _player != null) {
			// this is here to keep the data when the player logs off
			_name = _player.getName();
			_level = _player.getLevel();
			_classId = _player.getClassId().getId();
			_objectId = _player.getObjectId();
//			_powerGrade = _player.getPowerGrade();
//			_pledgeType = _player.getPledgeType();
//			_title = _player.getTitle();
//			_apprentice = _player.getApprentice();
//			_sponsor = _player.getSponsor();
//			_sex = _player.getAppearance().getSex();
//			_raceOrdinal = _player.getBioType().ordinal();
		}

//		if (player != null) {
//			if (_clan.getReputationScore() >= 0) {
//				L2Skill[] skills = _clan.getAllSkills();
//				for (L2Skill sk : skills) {
//					if (sk.getMinPledgeClass() <= player.getPledgeClass())
//						player.addSkill(sk, false);
//				}
//			}
//			if (_clan.getLevel() > 3 && player.isClanLeader())
//				SiegeManager.getInstance().addSiegeSkills(player);
//			if (player.isClanLeader())
//				_clan.setLeader(this);
//		}

		_player = player;
	}

	public FuzePcInstance getPlayerInstance() {
		return _player;
	}

	public boolean isOnline() {
		if (_player == null)
			return false;
		if (_player.getClient() == null)
			return false;
		if (_player.getClient().isDetached())
			return false;

		return true;
	}

	/**
	 * @return Returns the classId.
	 */
	public int getClassId() {
		if (_player != null) {
			return _player.getClassId().getId();
		}
		return _classId;
	}

	/**
	 * @return Returns the level.
	 */
	public int getLevel() {
		if (_player != null) {
			return _player.getLevel();
		}
		return _level;
	}

	/**
	 * @return Returns the name.
	 */
	public String getName() {
		if (_player != null) {
			return _player.getName();
		}
		return _name;
	}

	/**
	 * @return Returns the objectId.
	 */
	public long getObjectId() {
		if (_player != null) {
			return _player.getObjectId();
		}
		return _objectId;
	}

	public String getTitle() {
		if (_player != null) {
			return _player.getTitle();
		}
		return _title;
	}

	public int getPledgeType() {
//		if (_player != null) {
//			return _player.getPledgeType();
//		}
		return _pledgeType;
	}

	public void setPledgeType(int pledgeType) {
		_pledgeType = pledgeType;
//		if (_player != null) {
//			_player.setPledgeType(pledgeType);
//		} else {
//			//db save if char not logged in
//			updatePledgeType();
//		}
	}

	public void updatePledgeType() {
		Connection con = null;

		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE characters SET subpledge=? WHERE charId=?");
			statement.setLong(1, _pledgeType);
			statement.setLong(2, getObjectId());
			statement.execute();
			statement.close();
		} catch (Exception e) {
			//_log.warning("could not set char power_grade:"+e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	public int getPowerGrade() {
//		if (_player != null)
//			return _player.getPowerGrade();
		return _powerGrade;
	}

	/**
	 * @param powerGrade
	 */
	public void setPowerGrade(int powerGrade) {
		_powerGrade = powerGrade;
//		if (_player != null) {
//			_player.setPowerGrade(powerGrade);
//		} else {
//			// db save if char not logged in
//			updatePowerGrade();
//		}
	}

	/**
	 * Update the characters table of the database with power grade.<BR><BR>
	 */
	public void updatePowerGrade() {
		Connection con = null;

		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE characters SET power_grade=? WHERE charId=?");
			statement.setLong(1, _powerGrade);
			statement.setLong(2, getObjectId());
			statement.execute();
			statement.close();
		} catch (Exception e) {
			//_log.warning("could not set char power_grade:"+e);
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}

	public void initApprenticeAndSponsor(int apprenticeID, int sponsorID) {
		_apprentice = apprenticeID;
		_sponsor = sponsorID;
	}

	public int getRaceOrdinal() {
		if (_player != null)
			return _player.getRace().getId();
		else
			return _raceOrdinal;
	}

	public boolean getSex() {
//		if (_player != null)
//			return _player.getAppearance().getSex();
//		else
//			return _sex;
		return false;
	}

	public int getSponsor() {
		if (_player != null)
			return _player.getSponsor();
		else
			return _sponsor;
	}

	public int getApprentice() {
		if (_player != null)
			return _player.getApprentice();
		else
			return _apprentice;
	}

	public String getApprenticeOrSponsorName() {
		if (_player != null) {
			_apprentice = _player.getApprentice();
			_sponsor = _player.getSponsor();
		}

		if (_apprentice != 0) {
			L2ClanMember apprentice = _clan.getClanMember(_apprentice);
			if (apprentice != null)
				return apprentice.getName();
			else
				return "Error";
		}
		if (_sponsor != 0) {
			L2ClanMember sponsor = _clan.getClanMember(_sponsor);
			if (sponsor != null)
				return sponsor.getName();
			else
				return "Error";
		}
		return "";
	}

	public L2Clan getClan() {
		return _clan;
	}

	public int calculatePledgeClass(FuzePcInstance player) {
		int pledgeClass = 0;

		if (player == null)
			return pledgeClass;

		L2Clan clan = player.getClan();
		if (clan != null) {
			switch (player.getClan().getLevel()) {
			case 4:
				if (player.isClanLeader())
					pledgeClass = 3;
				break;
			case 5:
				if (player.isClanLeader())
					pledgeClass = 4;
				else
					pledgeClass = 2;
				break;
			case 6:
//				switch (player.getPledgeType()) {
//				case -1:
//					pledgeClass = 1;
//					break;
//				case 100:
//				case 200:
//					pledgeClass = 2;
//					break;
//				case 0:
//					if (player.isClanLeader())
//						pledgeClass = 5;
//					else
//						switch (clan.getLeaderSubPledge(player.getObjectId())) {
//						case 100:
//						case 200:
//							pledgeClass = 4;
//							break;
//						case -1:
//						default:
//							pledgeClass = 3;
//							break;
//						}
//					break;
//				}
				break;
			case 7:
//				switch (player.getPledgeType()) {
//				case -1:
//					pledgeClass = 1;
//					break;
//				case 100:
//				case 200:
//					pledgeClass = 3;
//					break;
//				case 1001:
//				case 1002:
//				case 2001:
//				case 2002:
//					pledgeClass = 2;
//					break;
//				case 0:
//					if (player.isClanLeader())
//						pledgeClass = 7;
//					else
//						switch (clan.getLeaderSubPledge(player.getObjectId())) {
//						case 100:
//						case 200:
//							pledgeClass = 6;
//							break;
//						case 1001:
//						case 1002:
//						case 2001:
//						case 2002:
//							pledgeClass = 5;
//							break;
//						case -1:
//						default:
//							pledgeClass = 4;
//							break;
//						}
//					break;
//				}
				break;
			case 8:
//				switch (player.getPledgeType()) {
//				case -1:
//					pledgeClass = 1;
//					break;
//				case 100:
//				case 200:
//					pledgeClass = 4;
//					break;
//				case 1001:
//				case 1002:
//				case 2001:
//				case 2002:
//					pledgeClass = 3;
//					break;
//				case 0:
//					if (player.isClanLeader())
//						pledgeClass = 8;
//					else
//						switch (clan.getLeaderSubPledge(player.getObjectId())) {
//						case 100:
//						case 200:
//							pledgeClass = 7;
//							break;
//						case 1001:
//						case 1002:
//						case 2001:
//						case 2002:
//							pledgeClass = 6;
//							break;
//						case -1:
//						default:
//							pledgeClass = 5;
//							break;
//						}
//					break;
//				}
				break;
			case 9:
//				switch (player.getPledgeType()) {
//				case -1:
//					pledgeClass = 1;
//					break;
//				case 100:
//				case 200:
//					pledgeClass = 5;
//					break;
//				case 1001:
//				case 1002:
//				case 2001:
//				case 2002:
//					pledgeClass = 4;
//					break;
//				case 0:
//					if (player.isClanLeader())
//						pledgeClass = 9;
//					else
//						switch (clan.getLeaderSubPledge(player.getObjectId())) {
//						case 100:
//						case 200:
//							pledgeClass = 8;
//							break;
//						case 1001:
//						case 1002:
//						case 2001:
//						case 2002:
//							pledgeClass = 7;
//							break;
//						case -1:
//						default:
//							pledgeClass = 6;
//							break;
//						}
//					break;
//				}
				break;
			case 10:
//				switch (player.getPledgeType()) {
//				case -1:
//					pledgeClass = 1;
//					break;
//				case 100:
//				case 200:
//					pledgeClass = 6;
//					break;
//				case 1001:
//				case 1002:
//				case 2001:
//				case 2002:
//					pledgeClass = 5;
//					break;
//				case 0:
//					if (player.isClanLeader())
//						pledgeClass = 10;
//					else
//						switch (clan.getLeaderSubPledge(player.getObjectId())) {
//						case 100:
//						case 200:
//							pledgeClass = 9;
//							break;
//						case 1001:
//						case 1002:
//						case 2001:
//						case 2002:
//							pledgeClass = 8;
//							break;
//						case -1:
//						default:
//							pledgeClass = 7;
//							break;
//						}
//					break;
//				}
				break;

			default:
				pledgeClass = 1;
				break;
			}
		}
		return pledgeClass;
	}

	public void saveApprenticeAndSponsor(int apprentice, int sponsor) {
		Connection con = null;

		try {
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("UPDATE characters SET apprentice=?,sponsor=? WHERE charId=?");
			statement.setInt(1, apprentice);
			statement.setInt(2, sponsor);
			statement.setLong(3, getObjectId());
			statement.execute();
			statement.close();
		} catch (SQLException e) {
			//_log.warning("could not set apprentice/sponsor:"+e.getMessage());
		} finally {
			try {
				con.close();
			} catch (Exception e) {
			}
		}
	}
}
